package com.giscloud.limp.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * ${comments}
 *
 * @author giscloud
 * @email giscloud@giscloud.com
 * @date 2020-06-10 19:33:46
 */
public class CompanyBlacklistExample {
    protected String orderByClause;
    protected boolean distinct;
    protected List<Criteria> oredCriteria;
    public CompanyBlacklistExample() {
        oredCriteria = new ArrayList<Criteria>();
    }
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }
    public String getOrderByClause() {
        return orderByClause;
    }
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }
    public boolean isDistinct() {
        return distinct;
    }
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

                                    public Criteria andCompanyListIdIsNull() {
                    addCriterion("company_list_id is null");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdIsNotNull() {
                    addCriterion("company_list_id is not null");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdEqualTo(Integer value) {
                    addCriterion("company_list_id =", value, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdNotEqualTo(Integer value) {
                    addCriterion("company_list_id <>", value, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdGreaterThan(Integer value) {
                    addCriterion("company_list_id >", value, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("company_list_id >=", value, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdLessThan(Integer value) {
                    addCriterion("company_list_id <", value, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdLessThanOrEqualTo(Integer value) {
                    addCriterion("company_list_id <=", value, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdIn(List<Integer> values) {
                    addCriterion("company_list_id in", values, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdNotIn(List<Integer> values) {
                    addCriterion("company_list_id not in", values, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdBetween(Integer value1, Integer value2) {
                    addCriterion("company_list_id between", value1, value2, "companyListId");
                    return (Criteria) this;
                }

                public Criteria andCompanyListIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("company_list_id not between", value1, value2, "companyListId");
                    return (Criteria) this;
                }
                            public Criteria andCompanyNameLike(String value) {
                    addCriterion("company_name like", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameNotLike(String value) {
                    addCriterion("company_name not like", value, "companyName");
                    return (Criteria) this;
                }
                            public Criteria andCompanyNameIsNull() {
                    addCriterion("company_name is null");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameIsNotNull() {
                    addCriterion("company_name is not null");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameEqualTo(String value) {
                    addCriterion("company_name =", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameNotEqualTo(String value) {
                    addCriterion("company_name <>", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameGreaterThan(String value) {
                    addCriterion("company_name >", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
                    addCriterion("company_name >=", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameLessThan(String value) {
                    addCriterion("company_name <", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameLessThanOrEqualTo(String value) {
                    addCriterion("company_name <=", value, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameIn(List<String> values) {
                    addCriterion("company_name in", values, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameNotIn(List<String> values) {
                    addCriterion("company_name not in", values, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameBetween(String value1, String value2) {
                    addCriterion("company_name between", value1, value2, "companyName");
                    return (Criteria) this;
                }

                public Criteria andCompanyNameNotBetween(String value1, String value2) {
                    addCriterion("company_name not between", value1, value2, "companyName");
                    return (Criteria) this;
                }
                            public Criteria andUniformSocialCreditCodeLike(String value) {
                    addCriterion("uniform_social_credit_code like", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeNotLike(String value) {
                    addCriterion("uniform_social_credit_code not like", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }
                            public Criteria andUniformSocialCreditCodeIsNull() {
                    addCriterion("uniform_social_credit_code is null");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeIsNotNull() {
                    addCriterion("uniform_social_credit_code is not null");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeEqualTo(String value) {
                    addCriterion("uniform_social_credit_code =", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeNotEqualTo(String value) {
                    addCriterion("uniform_social_credit_code <>", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeGreaterThan(String value) {
                    addCriterion("uniform_social_credit_code >", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeGreaterThanOrEqualTo(String value) {
                    addCriterion("uniform_social_credit_code >=", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeLessThan(String value) {
                    addCriterion("uniform_social_credit_code <", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeLessThanOrEqualTo(String value) {
                    addCriterion("uniform_social_credit_code <=", value, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeIn(List<String> values) {
                    addCriterion("uniform_social_credit_code in", values, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeNotIn(List<String> values) {
                    addCriterion("uniform_social_credit_code not in", values, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeBetween(String value1, String value2) {
                    addCriterion("uniform_social_credit_code between", value1, value2, "uniformSocialCreditCode");
                    return (Criteria) this;
                }

                public Criteria andUniformSocialCreditCodeNotBetween(String value1, String value2) {
                    addCriterion("uniform_social_credit_code not between", value1, value2, "uniformSocialCreditCode");
                    return (Criteria) this;
                }
                            public Criteria andContactsLike(String value) {
                    addCriterion("contacts like", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsNotLike(String value) {
                    addCriterion("contacts not like", value, "contacts");
                    return (Criteria) this;
                }
                            public Criteria andContactsIsNull() {
                    addCriterion("contacts is null");
                    return (Criteria) this;
                }

                public Criteria andContactsIsNotNull() {
                    addCriterion("contacts is not null");
                    return (Criteria) this;
                }

                public Criteria andContactsEqualTo(String value) {
                    addCriterion("contacts =", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsNotEqualTo(String value) {
                    addCriterion("contacts <>", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsGreaterThan(String value) {
                    addCriterion("contacts >", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsGreaterThanOrEqualTo(String value) {
                    addCriterion("contacts >=", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsLessThan(String value) {
                    addCriterion("contacts <", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsLessThanOrEqualTo(String value) {
                    addCriterion("contacts <=", value, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsIn(List<String> values) {
                    addCriterion("contacts in", values, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsNotIn(List<String> values) {
                    addCriterion("contacts not in", values, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsBetween(String value1, String value2) {
                    addCriterion("contacts between", value1, value2, "contacts");
                    return (Criteria) this;
                }

                public Criteria andContactsNotBetween(String value1, String value2) {
                    addCriterion("contacts not between", value1, value2, "contacts");
                    return (Criteria) this;
                }
                            public Criteria andContactTelLike(String value) {
                    addCriterion("contact_tel like", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelNotLike(String value) {
                    addCriterion("contact_tel not like", value, "contactTel");
                    return (Criteria) this;
                }
                            public Criteria andContactTelIsNull() {
                    addCriterion("contact_tel is null");
                    return (Criteria) this;
                }

                public Criteria andContactTelIsNotNull() {
                    addCriterion("contact_tel is not null");
                    return (Criteria) this;
                }

                public Criteria andContactTelEqualTo(String value) {
                    addCriterion("contact_tel =", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelNotEqualTo(String value) {
                    addCriterion("contact_tel <>", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelGreaterThan(String value) {
                    addCriterion("contact_tel >", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelGreaterThanOrEqualTo(String value) {
                    addCriterion("contact_tel >=", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelLessThan(String value) {
                    addCriterion("contact_tel <", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelLessThanOrEqualTo(String value) {
                    addCriterion("contact_tel <=", value, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelIn(List<String> values) {
                    addCriterion("contact_tel in", values, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelNotIn(List<String> values) {
                    addCriterion("contact_tel not in", values, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelBetween(String value1, String value2) {
                    addCriterion("contact_tel between", value1, value2, "contactTel");
                    return (Criteria) this;
                }

                public Criteria andContactTelNotBetween(String value1, String value2) {
                    addCriterion("contact_tel not between", value1, value2, "contactTel");
                    return (Criteria) this;
                }
                            public Criteria andWebsiteLike(String value) {
                    addCriterion("website like", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteNotLike(String value) {
                    addCriterion("website not like", value, "website");
                    return (Criteria) this;
                }
                            public Criteria andWebsiteIsNull() {
                    addCriterion("website is null");
                    return (Criteria) this;
                }

                public Criteria andWebsiteIsNotNull() {
                    addCriterion("website is not null");
                    return (Criteria) this;
                }

                public Criteria andWebsiteEqualTo(String value) {
                    addCriterion("website =", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteNotEqualTo(String value) {
                    addCriterion("website <>", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteGreaterThan(String value) {
                    addCriterion("website >", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteGreaterThanOrEqualTo(String value) {
                    addCriterion("website >=", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteLessThan(String value) {
                    addCriterion("website <", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteLessThanOrEqualTo(String value) {
                    addCriterion("website <=", value, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteIn(List<String> values) {
                    addCriterion("website in", values, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteNotIn(List<String> values) {
                    addCriterion("website not in", values, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteBetween(String value1, String value2) {
                    addCriterion("website between", value1, value2, "website");
                    return (Criteria) this;
                }

                public Criteria andWebsiteNotBetween(String value1, String value2) {
                    addCriterion("website not between", value1, value2, "website");
                    return (Criteria) this;
                }
                            public Criteria andEmailLike(String value) {
                    addCriterion("email like", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailNotLike(String value) {
                    addCriterion("email not like", value, "email");
                    return (Criteria) this;
                }
                            public Criteria andEmailIsNull() {
                    addCriterion("email is null");
                    return (Criteria) this;
                }

                public Criteria andEmailIsNotNull() {
                    addCriterion("email is not null");
                    return (Criteria) this;
                }

                public Criteria andEmailEqualTo(String value) {
                    addCriterion("email =", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailNotEqualTo(String value) {
                    addCriterion("email <>", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailGreaterThan(String value) {
                    addCriterion("email >", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailGreaterThanOrEqualTo(String value) {
                    addCriterion("email >=", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailLessThan(String value) {
                    addCriterion("email <", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailLessThanOrEqualTo(String value) {
                    addCriterion("email <=", value, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailIn(List<String> values) {
                    addCriterion("email in", values, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailNotIn(List<String> values) {
                    addCriterion("email not in", values, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailBetween(String value1, String value2) {
                    addCriterion("email between", value1, value2, "email");
                    return (Criteria) this;
                }

                public Criteria andEmailNotBetween(String value1, String value2) {
                    addCriterion("email not between", value1, value2, "email");
                    return (Criteria) this;
                }
                            public Criteria andAddressLike(String value) {
                    addCriterion("address like", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressNotLike(String value) {
                    addCriterion("address not like", value, "address");
                    return (Criteria) this;
                }
                            public Criteria andAddressIsNull() {
                    addCriterion("address is null");
                    return (Criteria) this;
                }

                public Criteria andAddressIsNotNull() {
                    addCriterion("address is not null");
                    return (Criteria) this;
                }

                public Criteria andAddressEqualTo(String value) {
                    addCriterion("address =", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressNotEqualTo(String value) {
                    addCriterion("address <>", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressGreaterThan(String value) {
                    addCriterion("address >", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressGreaterThanOrEqualTo(String value) {
                    addCriterion("address >=", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressLessThan(String value) {
                    addCriterion("address <", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressLessThanOrEqualTo(String value) {
                    addCriterion("address <=", value, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressIn(List<String> values) {
                    addCriterion("address in", values, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressNotIn(List<String> values) {
                    addCriterion("address not in", values, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressBetween(String value1, String value2) {
                    addCriterion("address between", value1, value2, "address");
                    return (Criteria) this;
                }

                public Criteria andAddressNotBetween(String value1, String value2) {
                    addCriterion("address not between", value1, value2, "address");
                    return (Criteria) this;
                }
                            public Criteria andCompanyLogoLike(String value) {
                    addCriterion("company_logo like", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoNotLike(String value) {
                    addCriterion("company_logo not like", value, "companyLogo");
                    return (Criteria) this;
                }
                            public Criteria andCompanyLogoIsNull() {
                    addCriterion("company_logo is null");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoIsNotNull() {
                    addCriterion("company_logo is not null");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoEqualTo(String value) {
                    addCriterion("company_logo =", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoNotEqualTo(String value) {
                    addCriterion("company_logo <>", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoGreaterThan(String value) {
                    addCriterion("company_logo >", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoGreaterThanOrEqualTo(String value) {
                    addCriterion("company_logo >=", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoLessThan(String value) {
                    addCriterion("company_logo <", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoLessThanOrEqualTo(String value) {
                    addCriterion("company_logo <=", value, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoIn(List<String> values) {
                    addCriterion("company_logo in", values, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoNotIn(List<String> values) {
                    addCriterion("company_logo not in", values, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoBetween(String value1, String value2) {
                    addCriterion("company_logo between", value1, value2, "companyLogo");
                    return (Criteria) this;
                }

                public Criteria andCompanyLogoNotBetween(String value1, String value2) {
                    addCriterion("company_logo not between", value1, value2, "companyLogo");
                    return (Criteria) this;
                }
                                    public Criteria andReportOrgIdIsNull() {
                    addCriterion("report_org_id is null");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdIsNotNull() {
                    addCriterion("report_org_id is not null");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdEqualTo(Integer value) {
                    addCriterion("report_org_id =", value, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdNotEqualTo(Integer value) {
                    addCriterion("report_org_id <>", value, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdGreaterThan(Integer value) {
                    addCriterion("report_org_id >", value, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("report_org_id >=", value, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdLessThan(Integer value) {
                    addCriterion("report_org_id <", value, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdLessThanOrEqualTo(Integer value) {
                    addCriterion("report_org_id <=", value, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdIn(List<Integer> values) {
                    addCriterion("report_org_id in", values, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdNotIn(List<Integer> values) {
                    addCriterion("report_org_id not in", values, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdBetween(Integer value1, Integer value2) {
                    addCriterion("report_org_id between", value1, value2, "reportOrgId");
                    return (Criteria) this;
                }

                public Criteria andReportOrgIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("report_org_id not between", value1, value2, "reportOrgId");
                    return (Criteria) this;
                }
                            public Criteria andReportOrgNameLike(String value) {
                    addCriterion("report_org_name like", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameNotLike(String value) {
                    addCriterion("report_org_name not like", value, "reportOrgName");
                    return (Criteria) this;
                }
                            public Criteria andReportOrgNameIsNull() {
                    addCriterion("report_org_name is null");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameIsNotNull() {
                    addCriterion("report_org_name is not null");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameEqualTo(String value) {
                    addCriterion("report_org_name =", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameNotEqualTo(String value) {
                    addCriterion("report_org_name <>", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameGreaterThan(String value) {
                    addCriterion("report_org_name >", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameGreaterThanOrEqualTo(String value) {
                    addCriterion("report_org_name >=", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameLessThan(String value) {
                    addCriterion("report_org_name <", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameLessThanOrEqualTo(String value) {
                    addCriterion("report_org_name <=", value, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameIn(List<String> values) {
                    addCriterion("report_org_name in", values, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameNotIn(List<String> values) {
                    addCriterion("report_org_name not in", values, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameBetween(String value1, String value2) {
                    addCriterion("report_org_name between", value1, value2, "reportOrgName");
                    return (Criteria) this;
                }

                public Criteria andReportOrgNameNotBetween(String value1, String value2) {
                    addCriterion("report_org_name not between", value1, value2, "reportOrgName");
                    return (Criteria) this;
                }
                                    public Criteria andBlacklistReasonIsNull() {
                    addCriterion("blacklist_reason is null");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonIsNotNull() {
                    addCriterion("blacklist_reason is not null");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonEqualTo(Integer value) {
                    addCriterion("blacklist_reason =", value, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonNotEqualTo(Integer value) {
                    addCriterion("blacklist_reason <>", value, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonGreaterThan(Integer value) {
                    addCriterion("blacklist_reason >", value, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonGreaterThanOrEqualTo(Integer value) {
                    addCriterion("blacklist_reason >=", value, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonLessThan(Integer value) {
                    addCriterion("blacklist_reason <", value, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonLessThanOrEqualTo(Integer value) {
                    addCriterion("blacklist_reason <=", value, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonIn(List<Integer> values) {
                    addCriterion("blacklist_reason in", values, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonNotIn(List<Integer> values) {
                    addCriterion("blacklist_reason not in", values, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonBetween(Integer value1, Integer value2) {
                    addCriterion("blacklist_reason between", value1, value2, "blacklistReason");
                    return (Criteria) this;
                }

                public Criteria andBlacklistReasonNotBetween(Integer value1, Integer value2) {
                    addCriterion("blacklist_reason not between", value1, value2, "blacklistReason");
                    return (Criteria) this;
                }
                            public Criteria andRemarkLike(String value) {
                    addCriterion("remark like", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkNotLike(String value) {
                    addCriterion("remark not like", value, "remark");
                    return (Criteria) this;
                }
                            public Criteria andRemarkIsNull() {
                    addCriterion("remark is null");
                    return (Criteria) this;
                }

                public Criteria andRemarkIsNotNull() {
                    addCriterion("remark is not null");
                    return (Criteria) this;
                }

                public Criteria andRemarkEqualTo(String value) {
                    addCriterion("remark =", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkNotEqualTo(String value) {
                    addCriterion("remark <>", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkGreaterThan(String value) {
                    addCriterion("remark >", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkGreaterThanOrEqualTo(String value) {
                    addCriterion("remark >=", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkLessThan(String value) {
                    addCriterion("remark <", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkLessThanOrEqualTo(String value) {
                    addCriterion("remark <=", value, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkIn(List<String> values) {
                    addCriterion("remark in", values, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkNotIn(List<String> values) {
                    addCriterion("remark not in", values, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkBetween(String value1, String value2) {
                    addCriterion("remark between", value1, value2, "remark");
                    return (Criteria) this;
                }

                public Criteria andRemarkNotBetween(String value1, String value2) {
                    addCriterion("remark not between", value1, value2, "remark");
                    return (Criteria) this;
                }
                                    public Criteria andAuditStatusIsNull() {
                    addCriterion("audit_status is null");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusIsNotNull() {
                    addCriterion("audit_status is not null");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusEqualTo(Integer value) {
                    addCriterion("audit_status =", value, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusNotEqualTo(Integer value) {
                    addCriterion("audit_status <>", value, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusGreaterThan(Integer value) {
                    addCriterion("audit_status >", value, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusGreaterThanOrEqualTo(Integer value) {
                    addCriterion("audit_status >=", value, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusLessThan(Integer value) {
                    addCriterion("audit_status <", value, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusLessThanOrEqualTo(Integer value) {
                    addCriterion("audit_status <=", value, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusIn(List<Integer> values) {
                    addCriterion("audit_status in", values, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusNotIn(List<Integer> values) {
                    addCriterion("audit_status not in", values, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusBetween(Integer value1, Integer value2) {
                    addCriterion("audit_status between", value1, value2, "auditStatus");
                    return (Criteria) this;
                }

                public Criteria andAuditStatusNotBetween(Integer value1, Integer value2) {
                    addCriterion("audit_status not between", value1, value2, "auditStatus");
                    return (Criteria) this;
                }
                            public Criteria andAuditRemarkLike(String value) {
                    addCriterion("audit_remark like", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkNotLike(String value) {
                    addCriterion("audit_remark not like", value, "auditRemark");
                    return (Criteria) this;
                }
                            public Criteria andAuditRemarkIsNull() {
                    addCriterion("audit_remark is null");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkIsNotNull() {
                    addCriterion("audit_remark is not null");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkEqualTo(String value) {
                    addCriterion("audit_remark =", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkNotEqualTo(String value) {
                    addCriterion("audit_remark <>", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkGreaterThan(String value) {
                    addCriterion("audit_remark >", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkGreaterThanOrEqualTo(String value) {
                    addCriterion("audit_remark >=", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkLessThan(String value) {
                    addCriterion("audit_remark <", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkLessThanOrEqualTo(String value) {
                    addCriterion("audit_remark <=", value, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkIn(List<String> values) {
                    addCriterion("audit_remark in", values, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkNotIn(List<String> values) {
                    addCriterion("audit_remark not in", values, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkBetween(String value1, String value2) {
                    addCriterion("audit_remark between", value1, value2, "auditRemark");
                    return (Criteria) this;
                }

                public Criteria andAuditRemarkNotBetween(String value1, String value2) {
                    addCriterion("audit_remark not between", value1, value2, "auditRemark");
                    return (Criteria) this;
                }
                                    public Criteria andStatusCdIsNull() {
                    addCriterion("status_cd is null");
                    return (Criteria) this;
                }

                public Criteria andStatusCdIsNotNull() {
                    addCriterion("status_cd is not null");
                    return (Criteria) this;
                }

                public Criteria andStatusCdEqualTo(Integer value) {
                    addCriterion("status_cd =", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdNotEqualTo(Integer value) {
                    addCriterion("status_cd <>", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdGreaterThan(Integer value) {
                    addCriterion("status_cd >", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("status_cd >=", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdLessThan(Integer value) {
                    addCriterion("status_cd <", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdLessThanOrEqualTo(Integer value) {
                    addCriterion("status_cd <=", value, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdIn(List<Integer> values) {
                    addCriterion("status_cd in", values, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdNotIn(List<Integer> values) {
                    addCriterion("status_cd not in", values, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdBetween(Integer value1, Integer value2) {
                    addCriterion("status_cd between", value1, value2, "statusCd");
                    return (Criteria) this;
                }

                public Criteria andStatusCdNotBetween(Integer value1, Integer value2) {
                    addCriterion("status_cd not between", value1, value2, "statusCd");
                    return (Criteria) this;
                }
                                    public Criteria andCreatedStaffIdIsNull() {
                    addCriterion("created_staff_id is null");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdIsNotNull() {
                    addCriterion("created_staff_id is not null");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdEqualTo(Integer value) {
                    addCriterion("created_staff_id =", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdNotEqualTo(Integer value) {
                    addCriterion("created_staff_id <>", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdGreaterThan(Integer value) {
                    addCriterion("created_staff_id >", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("created_staff_id >=", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdLessThan(Integer value) {
                    addCriterion("created_staff_id <", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdLessThanOrEqualTo(Integer value) {
                    addCriterion("created_staff_id <=", value, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdIn(List<Integer> values) {
                    addCriterion("created_staff_id in", values, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdNotIn(List<Integer> values) {
                    addCriterion("created_staff_id not in", values, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdBetween(Integer value1, Integer value2) {
                    addCriterion("created_staff_id between", value1, value2, "createdStaffId");
                    return (Criteria) this;
                }

                public Criteria andCreatedStaffIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("created_staff_id not between", value1, value2, "createdStaffId");
                    return (Criteria) this;
                }
                                    public Criteria andCreatedDtIsNull() {
                    addCriterion("created_dt is null");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtIsNotNull() {
                    addCriterion("created_dt is not null");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtEqualTo(Date value) {
                    addCriterion("created_dt =", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtNotEqualTo(Date value) {
                    addCriterion("created_dt <>", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtGreaterThan(Date value) {
                    addCriterion("created_dt >", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtGreaterThanOrEqualTo(Date value) {
                    addCriterion("created_dt >=", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtLessThan(Date value) {
                    addCriterion("created_dt <", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtLessThanOrEqualTo(Date value) {
                    addCriterion("created_dt <=", value, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtIn(List<Date> values) {
                    addCriterion("created_dt in", values, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtNotIn(List<Date> values) {
                    addCriterion("created_dt not in", values, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtBetween(Date value1, Date value2) {
                    addCriterion("created_dt between", value1, value2, "createdDt");
                    return (Criteria) this;
                }

                public Criteria andCreatedDtNotBetween(Date value1, Date value2) {
                    addCriterion("created_dt not between", value1, value2, "createdDt");
                    return (Criteria) this;
                }
                                    public Criteria andOperateStaffIdIsNull() {
                    addCriterion("operate_staff_id is null");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdIsNotNull() {
                    addCriterion("operate_staff_id is not null");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdEqualTo(Integer value) {
                    addCriterion("operate_staff_id =", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdNotEqualTo(Integer value) {
                    addCriterion("operate_staff_id <>", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdGreaterThan(Integer value) {
                    addCriterion("operate_staff_id >", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdGreaterThanOrEqualTo(Integer value) {
                    addCriterion("operate_staff_id >=", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdLessThan(Integer value) {
                    addCriterion("operate_staff_id <", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdLessThanOrEqualTo(Integer value) {
                    addCriterion("operate_staff_id <=", value, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdIn(List<Integer> values) {
                    addCriterion("operate_staff_id in", values, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdNotIn(List<Integer> values) {
                    addCriterion("operate_staff_id not in", values, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdBetween(Integer value1, Integer value2) {
                    addCriterion("operate_staff_id between", value1, value2, "operateStaffId");
                    return (Criteria) this;
                }

                public Criteria andOperateStaffIdNotBetween(Integer value1, Integer value2) {
                    addCriterion("operate_staff_id not between", value1, value2, "operateStaffId");
                    return (Criteria) this;
                }
                                    public Criteria andVersionIsNull() {
                    addCriterion("version is null");
                    return (Criteria) this;
                }

                public Criteria andVersionIsNotNull() {
                    addCriterion("version is not null");
                    return (Criteria) this;
                }

                public Criteria andVersionEqualTo(Date value) {
                    addCriterion("version =", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionNotEqualTo(Date value) {
                    addCriterion("version <>", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionGreaterThan(Date value) {
                    addCriterion("version >", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionGreaterThanOrEqualTo(Date value) {
                    addCriterion("version >=", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionLessThan(Date value) {
                    addCriterion("version <", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionLessThanOrEqualTo(Date value) {
                    addCriterion("version <=", value, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionIn(List<Date> values) {
                    addCriterion("version in", values, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionNotIn(List<Date> values) {
                    addCriterion("version not in", values, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionBetween(Date value1, Date value2) {
                    addCriterion("version between", value1, value2, "version");
                    return (Criteria) this;
                }

                public Criteria andVersionNotBetween(Date value1, Date value2) {
                    addCriterion("version not between", value1, value2, "version");
                    return (Criteria) this;
                }
                                    public Criteria andListDateIsNull() {
                    addCriterion("list_date is null");
                    return (Criteria) this;
                }

                public Criteria andListDateIsNotNull() {
                    addCriterion("list_date is not null");
                    return (Criteria) this;
                }

                public Criteria andListDateEqualTo(Date value) {
                    addCriterion("list_date =", value, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateNotEqualTo(Date value) {
                    addCriterion("list_date <>", value, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateGreaterThan(Date value) {
                    addCriterion("list_date >", value, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateGreaterThanOrEqualTo(Date value) {
                    addCriterion("list_date >=", value, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateLessThan(Date value) {
                    addCriterion("list_date <", value, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateLessThanOrEqualTo(Date value) {
                    addCriterion("list_date <=", value, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateIn(List<Date> values) {
                    addCriterion("list_date in", values, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateNotIn(List<Date> values) {
                    addCriterion("list_date not in", values, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateBetween(Date value1, Date value2) {
                    addCriterion("list_date between", value1, value2, "listDate");
                    return (Criteria) this;
                }

                public Criteria andListDateNotBetween(Date value1, Date value2) {
                    addCriterion("list_date not between", value1, value2, "listDate");
                    return (Criteria) this;
                }
            }


}